if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].InsertTransactionRecord') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].InsertTransactionRecord

GO


CREATE PROCEDURE dbo.InsertTransactionRecord
	@ID bigint,
	@SourceTableId int,
	@TrackingMask varchar(258),
	@UserName VarChar(50),
	@HostName VarChar(50),
	@AppName VarChar(100),
	@ChangeDate DateTime,
	@Spid Int,
	@CmdType VarChar(10)
AS

INSERT INTO dbo.[ChangeTransaction]
           ([ID]
           ,[SourceTableId]
           ,[TrackingMask]
           ,[UserName]
           ,[HostName]
           ,[AppName]
           ,[ChangeDate]
           ,[Spid]
           ,[CmdType])
     VALUES
           (@ID,
			@SourceTableId,
			@TrackingMask,
			@UserName,
			@HostName,
			@AppName,
			@ChangeDate,
			@Spid,
			@CmdType)